Platform Integration
Acumen integrates with multiple schedule planning programs, risk analysis programs, cost analysis programs, and MS Excel.
By integrating with multiple programs, Acumen can minimize the issues that arise when projects or programs have multiple planning platforms in use.
Linking to External Data
After you have created a new workbook, you can link to external data using the Get External Data From group on the S1 // Projects tab.
You create links and mappings between your workbook and one or more data sources in order to determine the project data source. Linking is the precursor step to importing the data.
A workbook can have an unlimited number of links to external sources. After an external source is linked, default field mappings are applied between the source data and the Acumen workbook. These mappings are fully configurable.
Importing Data
After you link to the external data source, the next step is to import the data. Prior to importing, you may want to filter the project data.
Platforms Supported for Risk Analysis
The following platforms are supported for use with Acumen's Risk Analysis (S3 // Risk tab):
- Microsoft Project Professional
- Microsoft Project Server
- Primavera P6 Web
- Primavera P6 XER
- Primavera P6 XML
- Phoenix Project Manager
- Open Plan
- Open Plan BK3 (backup file)
- UN/CEFACT
- Safran Project
If you import a project from any other platform, you will not see the project on the S3 // Risk tab.
Merging Datasets from Different Sources
Acumen includes a utility for merging datasets from different sources into a single set of data that can subsequently be analyzed. You can use this integration feature to combine cost and schedule information. For example, Acumen can merge a cost estimate from Excel with a schedule created in MS Project or Primavera.
Non-standard fields can also be imported/merged by drag-dropping the merge fields into the Acumen field list in the field mapping view. Available mapped fields are displayed in the source field list highlighted in green. The merge file must have a column called ID in order to bind the merge data with activities in the Acumen workbook.
- Related Topics:
- Microsoft Project Platform Integration
Acumen allows you to link to and import data from Microsoft Project, Microsoft Project Server, and Project Online (the hosted version of Project Server). - Oracle Primavera Platform Integration
This topic describes options and steps specific to Oracle Primavera projects. - Microsoft Excel Platform Integration
This topic describes options and information specific to Microsoft Excel files, Deltek Cobra's CAP report, and ARES PRISM G2 data. - Deltek Open Plan Platform Integration
Acumen can link directly to an Open Plan project in the database or to a project in a BK3 file. - Deltek Cobra / Cost Platform Integration
You can import cost data from a Deltek Cobra data file and/or a Work Authorization Document (WAD). - Deltek CSV Format Platform Integration
You can import cost data from other programs into Acumen using a .csv file format. - IPMDAR Platform Integration
The Integrated Program Management Data Analysis Report format (IPMDAR) is a Department of Defense contractor reporting format that uses the JSON data-exchange format. You can import IPMDAR contract performance and schedule data into Acumen, and you can also export data to an IPMDAR file. - Phoenix Project Manager Platform Integration
Import CPM schedules directly from Phoenix Project Manager for use in project analysis and acceleration in the full Acumen software suite. - Asta Powerproject Platform Integration
Acumen links to Asta Powerproject schedules that have been saved in the Asta Powerproject .pp file format. - UN/CEFACT XML Schedule Files Platform Integration
Acumen links to schedule files that use the UN/CEFACT XML Schema (IPMR Format 6 v1.0). - Safran Project Platform Integration
Acumen links to Safran Project 5 through exported Safran Project (.SP) files. - Deltek Cobra CAP Earned Value Platform Integration
You can link to detailed phase-based Earned Value (EV) data from Deltek Cobra's Excel-based CAP report. Importing a CAP report into Acumen enables Earned Value metrics to be run during an analysis. - ARES PRISM G2 Platform Integration
Link to detailed phase-based Earned Value (EV) data from ARES PRISM. This is a flexible means of analyzing time-phased cost data.